﻿CREATE TABLE [Admin].[clientSession] (
    [clientSession_id]                                 UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [clientSession_name]                               NVARCHAR (255)   NOT NULL,
    [clientSession_testServerId]                       UNIQUEIDENTIFIER NOT NULL,
    [clientSession_testSessionId]                      UNIQUEIDENTIFIER NOT NULL,
    [clientSession_enableLog]                          BIT              NOT NULL,
    [clientSession_scheduledStartDateTime]             DATETIME         NOT NULL,
    [clientSession_testScenarioId]                     UNIQUEIDENTIFIER NOT NULL,
    [clientSession_readyToStart]                       BIT              NOT NULL,
    [clientSession_readyToStartDateTime]               DATETIME         NULL,
    [clientSession_readyToStartDateTimeOnServer]       DATETIME         NULL,
    [clientSession_processId]                          INT              NULL,
    [clientSession_startDateTime]                      DATETIME         NULL,
    [clientSession_startDateTimeOnServer]              DATETIME         NULL,
    [clientSession_endDateTime]                        DATETIME         NULL,
    [clientSession_endDateTimeOnServer]                DATETIME         NULL,
    [clientSession_error]                              NVARCHAR (MAX)   NULL
);









